Download DB2 11.1 Fundamentals for LUW.C2090-616.PracticeTest.2018-09-19.34q.vcex

Vendor: IBM
Exam Code: C2090-616
Exam Name: DB2 11.1 Fundamentals for LUW
Date: Sep 19, 2018
File Size: 59 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
What type of function is created using the following command? 
CREATE FUNCTION TAN (X DOUBLE) 
RETURNS DOUBLE 
LANGUAGE SQL 
CONTAINS SQL 
NO EXTERNAL ACTION 
DETERMINISTIC 
RETURN SIN(X)/COS(X)
  1. Row
  2. Table
  3. Scalar
  4. External
Correct answer: C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createfuncinlinesqlscalar.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/db2z_sql_createfuncinlinesqlscalar.html
Question 2
What of the following is TRUE about triggers?
  1. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
  2. Triggers can be used to perform data manipulation operations against complex views
  3. Triggers can only be used to execute logic before or after appropriate SQL statements
  4. Only one trigger for a particular event and activation time can be created for a particular table
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html
Question 3
What is the purpose of a role?
  1. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
  2. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
  3. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles
  4. To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group
Correct answer: A
Question 4
Which of the following authorities is sufficient for connecting to a database?
  1. SQLADM
  2. CONNECT
  3. DATAACESS
  4. ACCESSCTRL
Correct answer: D
Explanation:
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21427232
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21427232
Question 5
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
  1. DELETE FROM t1
  2. DELETE* FROM t1
  3. DELETE* TABLE t1
  4. TRUNCATE TABLE t1 IMMEDIATE
  5. TRUNCATE TABLE t1
Correct answer: AB
Question 6
Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?
  1. Sequence
  2. Row Identifier
  3. Identity Column
  4. Insert time clustering table
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sequencereference.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sequencereference.html
Question 7
Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)
  1. No other applications can access the table
  2. Only uncommitted read (UR) applications can access the table
  3. The lock owner and other applications can read, but not update, the locked table
  4. The lock owner can both read and update data. Other applications can read the table
  5. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped
Correct answer: AE
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
Question 8
Which of the following statements regarding locking is TRUE?
  1. The same lock modes apply to tables, rows, or blocks
  2. Lock conversion can take place implicitly as a query executes
  3. Changing the mode of a lock that is already held is called lock escalation
  4. Lock conversion is not necessary if an X lock is required and an S or U lock is currently held
Correct answer: B
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0021283.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0021283.html
Question 9
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
  1. DB2 HADR
  2. DB2 pureScale
  3. DB2 Express-C
  4. DS2 Database Partitioning Feature
Correct answer: B
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/c0054843.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/c0054843.html
Question 10
Which of the following statements will successfully create a table that scores index data in a different table space than the table data?
  1. CREATE TABLE t1 (c1 INT, c2 INT);
  2. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;
  3. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;
  4. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!